Release 10.1A: OpenEdge Reporting:
Query/Results for Windows

Before you begin

A query is a set of instructions that specifies the criteria by which information is extracted from a database. A query can retrieve data from one or more tables, from all the records in a table, or just a subset of records.

Once you have located the data you need through the use of a query, you can use a variety of sorting and filtering features to fine time and analyze the data. For example, to send catalogs to your current customers only, you might create a query to locate the names and addresses of all your customers who ordered merchandise in the last year. Then you can use the query to generate mailing labels, create printed reports, update the information stored in the database, and even create a data file to export the data to another application.

The remaining sections of this chapter provide procedural detail to create and use queries.